# -*- coding: utf-8 -*-

"""
以下是创建教练数据表的SQL语句，共有5个，都创建在同一个数据库“nba_database”中，DBMS——MySQL。
"""

coach_brief_introduction = """
CREATE TABLE IF NOT EXISTS coach_brief_introduction(
bi_id  int  NOT NULL  AUTO_INCREMENT,
bi_name  varchar(100)  NOT NULL,
bi_birthday  varchar(100)  COMMENT '出生日期',
bi_hometown  varchar(100)  COMMENT '出生城市',
bi_highschool  varchar(100)  COMMENT '高中',
bi_university  varchar(100)  COMMENT '大学',
bi_teaching_career  varchar(100)  COMMENT '执教生涯',
bi_season  varchar(100)  COMMENT '常规赛',
bi_playoff  varchar(100)  COMMENT '季后赛',
bi_finals  varchar(100)  COMMENT '总决赛',
bi_champion  varchar(100)  COMMENT '总冠军',
bi_best_coach  varchar(100)  COMMENT '最佳教练',
bi_hall_of_fame  varchar(100)  COMMENT '名人堂',
PRIMARY KEY(bi_id)
)ENGINE=InnoDB;
"""

coach_season_data = """
CREATE TABLE IF NOT EXISTS coach_season_data(
sd_id  int  NOT NULL  AUTO_INCREMENT,
sd_name  varchar(100)  NOT NULL,
sd_season  varchar(50)  COMMENT '赛季',
sd_team  varchar(50)  COMMENT '球队',
sd_teaching  varchar(50)  COMMENT '执教',
sd_shot  varchar(50)  COMMENT '投篮',
sd_shothit  varchar(50)  COMMENT '投篮命中',
sd_shotto  varchar(50)  COMMENT '投篮出手',
sd_threepoints  varchar(50)  COMMENT '三分',
sd_tphit  varchar(50)  COMMENT '三分命中',
sd_tpshot  varchar(50)  COMMENT '三分出手',
sd_penalty  varchar(50)  COMMENT '罚球',
sd_phit  varchar(50)  COMMENT '罚球命中',
sd_pshot  varchar(50)  COMMENT '罚球出手',
sd_backboard  varchar(50)  COMMENT '篮板',
sd_bbfront  varchar(50)  COMMENT '前场篮板',
sd_bbback  varchar(50)  COMMENT '后场篮板',
sd_assist  varchar(50)  COMMENT '助攻',
sd_steal  varchar(50)  COMMENT '抢断',
sd_cap  varchar(50)  COMMENT '盖帽',
sd_mistake  varchar(50)  COMMENT '失误',
sd_foul  varchar(50)  COMMENT '犯规',
sd_score  varchar(50)  COMMENT '得分',
sd_win  varchar(50)  COMMENT '胜',
sd_negative  varchar(50)  COMMENT '负',
sd_winning_probability  varchar(50)  COMMENT '胜率',
PRIMARY KEY(sd_id)
)ENGINE=InnoDB;
"""

coach_season_data_count = """
CREATE TABLE IF NOT EXISTS coach_season_data_count(
sdc_id  int  NOT NULL  AUTO_INCREMENT,
sdc_name  varchar(100)  NOT NULL,
sdc_teaching_career  varchar(50)  COMMENT '执教生涯',
sdc_teaching_team  varchar(50)  COMMENT '执教球队',
sdc_teaching  varchar(50)  COMMENT '执教',
sdc_shot  varchar(50)  COMMENT '投篮',
sdc_shothit  varchar(50)  COMMENT '投篮命中',
sdc_shotto  varchar(50)  COMMENT '投篮出手',
sdc_threepoints  varchar(50)  COMMENT '三分',
sdc_tphit  varchar(50)  COMMENT '三分命中',
sdc_tpshot  varchar(50)  COMMENT '三分出手',
sdc_penalty  varchar(50)  COMMENT '罚球',
sdc_phit  varchar(50)  COMMENT '罚球命中',
sdc_pshot  varchar(50)  COMMENT '罚球出手',
sdc_backboard  varchar(50)  COMMENT '篮板',
sdc_bbfront  varchar(50)  COMMENT '前场篮板',
sdc_bbback  varchar(50)  COMMENT '后场篮板',
sdc_assist  varchar(50)  COMMENT '助攻',
sdc_steal  varchar(50)  COMMENT '抢断',
sdc_cap  varchar(50)  COMMENT '盖帽',
sdc_mistake  varchar(50)  COMMENT '失误',
sdc_foul  varchar(50)  COMMENT '犯规',
sdc_score  varchar(50)  COMMENT '得分',
sdc_win  varchar(50)  COMMENT '胜',
sdc_negative  varchar(50)  COMMENT '负',
sdc_winning_probability  varchar(50)  COMMENT '胜率',
PRIMARY KEY(sdc_id)
)ENGINE=InnoDB;
"""

coach_playoff_data = """
CREATE TABLE IF NOT EXISTS coach_playoff_data(
pd_id  int  NOT NULL  AUTO_INCREMENT,
pd_name  varchar(100)  NOT NULL,
pd_season  varchar(50)  COMMENT '赛季',
pd_team  varchar(50)  COMMENT '球队',
pd_teaching  varchar(50)  COMMENT '执教',
pd_shot  varchar(50)  COMMENT '投篮',
pd_shothit  varchar(50)  COMMENT '投篮命中',
pd_shotto  varchar(50)  COMMENT '投篮出手',
pd_threepoints  varchar(50)  COMMENT '三分',
pd_tphit  varchar(50)  COMMENT '三分命中',
pd_tpshot  varchar(50)  COMMENT '三分出手',
pd_penalty  varchar(50)  COMMENT '罚球',
pd_phit  varchar(50)  COMMENT '罚球命中',
pd_pshot  varchar(50)  COMMENT '罚球出手',
pd_backboard  varchar(50)  COMMENT '篮板',
pd_bbfront  varchar(50)  COMMENT '前场篮板',
pd_bbback  varchar(50)  COMMENT '后场篮板',
pd_assist  varchar(50)  COMMENT '助攻',
pd_steal  varchar(50)  COMMENT '抢断',
pd_cap  varchar(50)  COMMENT '盖帽',
pd_mistake  varchar(50)  COMMENT '失误',
pd_foul  varchar(50)  COMMENT '犯规',
pd_score  varchar(50)  COMMENT '得分',
pd_win  varchar(50)  COMMENT '胜',
pd_negative  varchar(50)  COMMENT '负',
pd_winning_probability  varchar(50)  COMMENT '胜率',
PRIMARY KEY(pd_id)
)ENGINE=InnoDB;
"""

coach_playoff_data_count = """
CREATE TABLE IF NOT EXISTS coach_playoff_data_count(
pdc_id  int  NOT NULL  AUTO_INCREMENT,
pdc_name  varchar(100)  NOT NULL,
pdc_teaching_career  varchar(50)  COMMENT '执教生涯',
pdc_teaching_team  varchar(50)  COMMENT '执教球队',
pdc_teaching  varchar(50)  COMMENT '执教',
pdc_shot  varchar(50)  COMMENT '投篮',
pdc_shothit  varchar(50)  COMMENT '投篮命中',
pdc_shotto  varchar(50)  COMMENT '投篮出手',
pdc_threepoints  varchar(50)  COMMENT '三分',
pdc_tphit  varchar(50)  COMMENT '三分命中',
pdc_tpshot  varchar(50)  COMMENT '三分出手',
pdc_penalty  varchar(50)  COMMENT '罚球',
pdc_phit  varchar(50)  COMMENT '罚球命中',
pdc_pshot  varchar(50)  COMMENT '罚球出手',
pdc_backboard  varchar(50)  COMMENT '篮板',
pdc_bbfront  varchar(50)  COMMENT '前场篮板',
pdc_bbback  varchar(50)  COMMENT '后场篮板',
pdc_assist  varchar(50)  COMMENT '助攻',
pdc_steal  varchar(50)  COMMENT '抢断',
pdc_cap  varchar(50)  COMMENT '盖帽',
pdc_mistake  varchar(50)  COMMENT '失误',
pdc_foul  varchar(50)  COMMENT '犯规',
pdc_score  varchar(50)  COMMENT '得分',
pdc_win  varchar(50)  COMMENT '胜',
pdc_negative  varchar(50)  COMMENT '负',
pdc_winning_probability  varchar(50)  COMMENT '胜率',
PRIMARY KEY(pdc_id)
)ENGINE=InnoDB;
"""